﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Dropthings.DAL;

namespace Dropthings.Business.Facade
{
    partial class Facade
    {
        //获取某个建筑或全部建筑某天的工作时间或非工作时间的各个小时耗水情况
        public DataSet GetWaterTimeDatasInWorkTimeOrNot(string identifyCode, int year, int month, int day,bool isWorkTime)
        {
            if (string.IsNullOrEmpty(identifyCode)) return null;
            UQ_GetWaterTimeDatasInOrNotinWorkTime query = new UQ_GetWaterTimeDatasInOrNotinWorkTime(identifyCode, year, month, day, isWorkTime);
            return query.ExecuteDataset();
        }
        
        //获取某个建筑或全部建筑某月的各天耗水情况
        public DataSet GetWaterDayDatasInMonth(string identifyCode, int year, int month)
        {
            if (string.IsNullOrEmpty(identifyCode)) return null;
            UQ_GetWaterDayDatasInMonth query = new UQ_GetWaterDayDatasInMonth(identifyCode, year, month);
            return query.ExecuteDataset();
        }
        
        //获取某个建筑或全部建筑某年的各月耗水情况
        public DataSet GetWaterMonthDatasInYear(string identifyCode, int year)
        {
            if (string.IsNullOrEmpty(identifyCode)) return null;
            UQ_GetWaterMonthDatasInYear query = new UQ_GetWaterMonthDatasInYear(identifyCode, year);
            return query.ExecuteDataset();
        }

        //获取某一年某个建筑单位(所有建筑单位)的水费
        public DataSet GetWaterTotalMoneyInYear(string identifyCode, int year)
        {
            if (string.IsNullOrEmpty(identifyCode)) return null;
            UQ_GetWaterTotalMoneyInYear query = new UQ_GetWaterTotalMoneyInYear(identifyCode, year);
            return query.ExecuteDataset();
        }
        //获取某一年某个建筑单位(所有建筑单位)各个月的水费
        public DataSet GetWaterMonthMoneyInYear(string identifyCode, int year)
        {
            if (string.IsNullOrEmpty(identifyCode)) return null;
            UQ_GetWaterMonthMoneyInYear query = new UQ_GetWaterMonthMoneyInYear(identifyCode, year);
            return query.ExecuteDataset();
        }
    }
}
